<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>:: Shanti Chakra Foundation ::</title>
<link href="style.css" rel="stylesheet" type="text/css">
<link rel="stylesheet" href="./css/yellow.css" />
        <link rel="stylesheet" href="./css/small.css" />
        <!-- Loading Calendar JavaScript files -->
        <script type="text/javascript" src="./js/zapatec.js"></script>
        <script type="text/javascript" src="./js/calendar.js"></script>
        <!-- Loading language definition file -->
        <script type="text/javascript" src="./js/calendar-en.js"></script>
        <meta http-equiv="content-type" content="text/xml; charset=utf-8" />
        

        <script type="text/javascript">
		function getXMLObject()  //XML OBJECT
            {
                var xmlHttp = false;
                try {
                    xmlHttp = new ActiveXObject("Msxml2.XMLHTTP")  // For Old Microsoft Browsers
                }
                catch (e) {
                    try {
                        xmlHttp = new ActiveXObject("Microsoft.XMLHTTP")  // For Microsoft IE 6.0+
                    }
                    catch (e2) {
                        xmlHttp = false   // No Browser accepts the XMLHTTP Object then false
                    }
                }
                if (!xmlHttp && typeof XMLHttpRequest != 'undefined') {
                    xmlHttp = new XMLHttpRequest();        //For Mozilla, Opera Browsers
                }
                return xmlHttp;  // Mandatory Statement returning the ajax object created
            }

            var xmlhttp = new getXMLObject();	//xmlhttp holds the ajax object
				
		function validate(register)
		{
		if ( register.name.value == "" )
		{
			alert("Enter Valid Name");
			register.name.focus() ;
			return false;
		}
    	if (register.surname.value == "")
		{
				alert("Enter valid surname");
				register.surname.focus();
				return false ;
		}
		if (register.age.value == "")
		{
			alert("Enter Valid Age");
			register.age.focus() ;
			return false;
		}
    	if (register.caste.value == "")
		{
				alert("Enter valid caste");
				register.caste.focus();
				return false ;
		}
		if (register.dob.value == "")
		{
			alert("Enter Valid Date of Birth");
			register.dob.focus() ;
			return false;
		}
    	if (register.resadd.value == "")
		{
				alert("Enter valid Residance");
				register.resadd.focus();
				return false ;
		}
        if (register.mobile.value == "")
		{
				alert("Enter valid mobile");
				register.mobile.focus();
				return false ;
		}
        
		if (register.prof.value=="--")
		{
				alert("Enter valid Proffession");
				register.prof.focus();
				return false ;
		}
       if(register.checkbox.checked == false )
			{ 
			
			alert("Click the declaration Check box");
			return false ;
			}
		}
		
			function SpouseSex()
			{
				var sex = document.getElementById("sex");
			 	var opt = sex.options[sex.selectedIndex];
			}

            function sendage()
            {
             	var dob1 = document.getElementById("dob").value;                
                //alert("date of birth is "+dob1);            
				var year=dob1.split("-");				
				var today=new Date();
				var byear=year[2];
				var cyear=today.getYear();
				document.getElementById("age").value=(parseInt(cyear)-parseInt(byear));
				document.getElementById("declage").value=(parseInt(cyear)-parseInt(byear));	
            }
			
			function Getdecl()
			{
			var dname = document.getElementById("name").value;
			document.getElementById("decl").value = dname;
			}
      		function getDistricts() {
                var sel = document.getElementById("state");
                var opt = sel.options[sel.selectedIndex];
                var d = opt.value || opt.text;

                if(xmlhttp) {
                    xmlhttp.open("GET","AJAXGetDistricts?state=" +d,true);
                    xmlhttp.onreadystatechange  = handleServerResponse;
                    xmlhttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
                    xmlhttp.send(null);
                }
            }
          function getMandals() {
                var districts = document.getElementById("district");
                var opt1 = districts.options[districts.selectedIndex];
                var d1= opt1.value || opt1.text;
                //alert(d1);
                if(xmlhttp) {
                    xmlhttp.open("GET","AJAXGetMandals?district=" +d1,true);
                    xmlhttp.onreadystatechange  = handleServerResponse1;
                    xmlhttp.setRequestHeader('Content-Type', 'application/x-www-form-urlencoded');
                    xmlhttp.send(null);
                }
            }
            function handleServerResponse() {
                if (xmlhttp.readyState == 4) {
                    if(xmlhttp.status == 200) {
                        document.getElementById('district').options.length = 0;
                        var elemnt = document.getElementById("district");
                        var textToSplit = xmlhttp.responseText;
                        var returnElements=textToSplit.split("|");
                        var valueLabelPair=null;

                        document.getElementById('district').options[0] = new Option("Select","select");
                        for ( var i=0; i<(returnElements.length-1); i++ ){
                            valueLabelPair = returnElements[i].split("|");
                            document.getElementById('district').options[i+1] = new Option(valueLabelPair[0], valueLabelPair[1]);
                        }
                    }else {
                        alert("AJAX Call Error Please try again");
                    }
                }
            }
            function handleServerResponse1() {
                if (xmlhttp.readyState == 4) {
                    if(xmlhttp.status == 200) {
                        document.getElementById('mandal').options.length = 0;
                        var elemnt = document.getElementById("mandal");
                        var textToSplit = xmlhttp.responseText;
                        var returnElements=textToSplit.split("|");
                        var valueLabelPair=null;
                        for ( var i=0; i<(returnElements.length-1); i++ ){
                            document.getElementById('mandal').options[i] = new Option("","");
                        }
                        document.getElementById('mandal').options[0] = new Option("Select","select");
                        for ( var i=0; i<(returnElements.length-1); i++ ){
                            valueLabelPair = returnElements[i].split("|");
                            document.getElementById('mandal').options[i+1] = new Option(valueLabelPair[0], valueLabelPair[1]);
                        }
                    }
					else {
                        alert("Error during AJAX call. Please try again");
                    }
                }
            }
        </script>
</head>
   <%@ page import="java.io.* ,java.util.*, java.sql.*, Login.*, Admin.*, Registration.* "%>
<%
        MySqlConnector ms = new MySqlConnector();
	ms.Connect();
        PreparedStatement stmt1 = ms.Connect().prepareStatement("Select distinct(qualname) from qualification ;");
        PreparedStatement stmt2 = ms.Connect().prepareStatement("select distinct(profname) from proffession ;");
        PreparedStatement stmt3 = ms.Connect().prepareStatement("select distinct(state) from states ;");
        ResultSet rs1 = stmt1.executeQuery();
        ResultSet rs2 = stmt2.executeQuery();
        ResultSet rs3 = stmt3.executeQuery();
%>

<body >
<a href="javascript:history.go(-1)">Back</a>
<%
HttpSession hs = request.getSession(true);
String id = (String) hs.getAttribute("memid");
%>
Welcome : <%=id%>.
<%
String rcheck;
RegistrationBean rbean ;
ViewMemberDao vmd ;
if(id.equals("SCFAdmin"))
{
System.out.println("in administrator place ---------"+id);
rbean = (RegistrationBean) request.getAttribute("rbeanedit") ;
System.out.println("rbean edit "+rbean);
rcheck = (String) session.getAttribute("view_rcheck");
System.out.println("in id = scfadmin condition :"+rcheck);
}
else 
{
rcheck = id;
System.out.println("in Users place ---------"+rcheck);
vmd = new ViewMemberDao();
rbean = vmd.view_member(rcheck);
System.out.println("status in edit member" + rbean);
if (rbean != null)
{
System.out.println("in user module jsp edit member - status true : ");
request.setAttribute("userbean", rbean);
}
vmd.view_member(rcheck);
System.out.println("Session is :"+rcheck);
}

%>
<form action="EditMember" method="post" enctype="multipart/form-data" name="form1" >
  <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" class="greenlink_no_left_padding" style="border-right: #F8C9CA 1px solid; border-top: #F8C9CA 1px solid; border-left: #F8C9CA 1px solid;  border-bottom: #F8C9CA; font-size: 9pt; color: #000000; font-family: Arial;">
                    <tr>
                        <td height="28" colspan="6" bgcolor="#D8F2C9" class="style44">
                      <h3 align="center" class="style43 style48">EDIT MEMBER DETAILS </h3></td>
                    </tr>
                    <tr>
                 <td colspan="6" bgcolor="#FFFF99" class="style38">
                     <div align="center">MEMBER " <%=rcheck%> " DETAILS</div>
                 </td>
                    </tr>
                    <tr>
                     
                      <td colspan="4" class="style38"><table width="100%" border="0" cellspacing="0" cellpadding="0" style="border-right: #F8C9CA 1px solid; border-top: #F8C9CA 1px solid; border-left: #F8C9CA 1px solid;  border-bottom: #F8C9CA 1px solid; font-size: 9pt; color: #000000; font-family: Arial;">
                        <tr>
                          <td><table width="100%" border="0" cellpadding="0" cellspacing="0" class="greenlink_no_left_padding" style="border-right: #F8C9CA 1px solid; border-top: #F8C9CA 1px solid; border-left: #F8C9CA 1px solid;  border-bottom: #F8C9CA 1px solid; font-size: 9pt; color: #000000; font-family: Arial;">
                            <tr>
                              <td height="24" colspan="2" align="center" bgcolor="#FFFFD5" class="bluetext">Personal Details </td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">NAME* :</span></td>
                              <td class="style40"><span class="style44 style40">
             <input type="text" name="name" id ="name"  value = "<%=rbean.getName() %>" onMouseMove="javascript:Getdecl()"/>
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">SURNAME*:</span></td>
                              <td class="style40"><span class="style44 style40">
                                <input name="surname" type="text" id = "surname" value = "<%=rbean.getSurname() %>"/>
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">SEX* :</span></td>
                              <td class="style40"><span class="style44 style40">
                                <select name="sex" id="sex" onChange="javascript:SpouseSex();">
                                  <option selected="selected" selected="selected"><%=rbean.getSex() %></option>
                                  <option>Male</option>
                                  <option>Female</option>
                                </select>
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">DATE OF BIRTH * :</span></td>
                              <td class="style40"><span class="style44 style40">
                            <input name="dob" type="text" class="tabledata" id="dob" size="15" value = "<%=rbean.getDob()%>" onChange="javascript:sendage();"/>
                            <input name="b1" type="button" id="b1" value="cal" />
                                <script type="text/javascript">
                                Zapatec.Calendar.setup({
                                    step              : 1,
                                    electric          : false,
                                    inputField        : "dob",
                                    button            : "b1",
                                    ifFormat          : "%d-%m-%Y",
                                    daFormat          : "%d-%m-%Y"
                                });
                              </script>
								AGE
                                <input name="age" type="text" id = "age" size="5" value = "<%=rbean.getAge() %>" />
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">CASTE : </span></td>
                              <td class="style40"><span class="style44 style40">
                                <input name="caste" type="text" id="caste" value = "<%=rbean.getCaste() %>"/>
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">MEMEBER PHOTO </span></td>
                              <td class="style40"><span class="style44 style40">
                                <input name = "photo" type="file" id="photo" value = "Upload Your Image"/>
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">QUALIFICATION :</span></td>
                              <td class="style40"><span class="style44 style40">
                                <select name="qual" id ="qual">
                                  <option selected="selected"><%=rbean.getQualification() %></option>
                                  <%
                                     while (rs1.next() == true) 
									{%>
                                  <option> <%=rs1.getString(1)%></option>
                                  <%System.out.print("qualification table qualname " + rs1.getString(1));
        							}
                                       %>
                                </select>
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">RESIDENCE ADDRESS*:</span></td>
                              <td class="style40"><span class="style44 style40">
                                <textarea name="resadd" id ="resadd"  ><%=rbean.getRes_add() %></textarea>
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">STATE*:</span></td>
                              <td class="style40"><span class="style44 style40">
                                <select name="state" id="state" onChange="javascript:getDistricts();">
                                  <option selected="selected"><%=rbean.getState()%> </option>
                                  <%
                                while (rs3.next() == true) {%>
                                  <option><%=rs3.getString(1)%></option>
                                  <%}%>
                                </select>
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">DISTRICT*:</span></td>
                              <td class="style40"><span class="style44 style40">
                                <select name="district" id="district" onChange="javascript:getMandals();">
                                <option selected="selected"><%=rbean.getDist() %> </option>
								</select>
                              </span></td>
                            </tr>
                            <tr>
                              <td class="greenlink_no_left_padding"><span class="style44 style40">Mandal*:</span></td>
                              <td class="style40"><span class="style44 style40">
                                <select name="mandal" id="mandal">
                                <option selected="selected"><%=rbean.getMandal() %> </option>
								</select>
                              </span></td>
                            </tr>
                          </table></td>
                          <td>
						  <table width="100%" border="0" cellpadding="0" cellspacing="0" class="greenlink_no_left_padding" style="border-right: #F8C9CA 1px solid; border-top: #F8C9CA 1px solid; border-left: #F8C9CA 1px solid;  border-bottom: #F8C9CA 1px solid; font-size: 9pt; color: #000000; font-family: Arial;">
                            <tr>
                              <td height="21" colspan="2" align="center" bgcolor="#FFFFD5" class="bluetext">Office Details </td>
                            </tr>
                            <tr>
                              <td align="left" bgcolor="#D8F2C9" class="greentext">PROFESSION/DESIGNATION*</td>
                              <td align="left" bgcolor="#D8F2C9" class="style40"><span class="style45">
                                <select name="prof" id="prof">
                                  <option value="--"> </option>
								  <option selected="selected"><%=rbean.getProf() %></option>
                                  <%while (rs2.next() == true) 
								{
                                %>
                                  <option><%=rs2.getString(1)%></option>
                                  <% System.out.print("Proffession table profname " + rs2.getString(1));
        						}
                                %>
                                  <option value="-" onClick="textbox_prof">other</option>
                              </select>
                              </span></td>
                            </tr>
                            <tr>
                              <td align="left" class="greentext">ORGANISATION NAME: </td>
                              <td align="left" class="style40">
							  <input name="org" type="text" value = "<%=rbean.getOrg()%>"/></td>
                            </tr>
                            <tr>
                              <td align="left" class="greentext">OFFICE ADDRESS: </td>
                              <td align="left"class="style40"><span class="style45">
                                <textarea name="offadd" id ="offadd" > <%=rbean.getOff_add() %> </textarea>
                              </span></td>
                            </tr>
                            <tr>
                              <td height="15" align="left" bgcolor="#D8F2C9" class="style44">&nbsp;</td>
                              <td align="left" bgcolor="#D8F2C9" class="style44">&nbsp;</td>
                            </tr>
                          </table>
                            <table width="100%" border="0" cellpadding="0" cellspacing="0" class="greenlink_no_left_padding" style="border-right: #F8C9CA 1px solid; border-top: #F8C9CA 1px solid; border-left: #F8C9CA 1px solid;  border-bottom: #F8C9CA 1px solid; font-size: 9pt; color: #000000; font-family: Arial;">
                              <tr>
                                <td height="21" colspan="2" align="center" bgcolor="#FFFFD5" class="bluetext">Contact Details </td>
                              </tr>
                              <tr>
                                <td width="52%" align="left" bgcolor="#D8F2C9" class="greentext">RESIDENCE </td>
                                <td width="48%" align="left" bgcolor="#D8F2C9" class="style45">
								<input type="text" name="rphone" id ="rphone" value = "<%=rbean.getRes_phone() %>" /></td>
                              </tr>
                              <tr>
                                <td align="left" bgcolor="#D8F2C9" class="greentext">OFFICE</td>
                                <td align="left" bgcolor="#D8F2C9" class="style45">
								<input type="text" name="ophone" value = "<%=rbean.getOff_phone() %>"/></td>
                              </tr>
                              <tr>
                                <td align="left" bgcolor="#D8F2C9" class="greentext">MOBILE*:</td>
                                <td align="left" bgcolor="#D8F2C9" class="style45">
								<input type="text" name="mobile" id="mobile" value = "<%=rbean.getMobile()%>"/></td>
                              </tr>
                              <tr>
                                <td align="left" bgcolor="#D8F2C9" class="greentext">EMAIL :</td>
                                <td align="left" bgcolor="#D8F2C9" class="style45">
								<input type="text" name="email" id ="email" value = "<%=rbean.getEmail() %>"/>								</td>
                              </tr>
                              <tr>
                                <td align="left" bgcolor="#D8F2C9" class="greentext">WEB ADDRESS:</td>
                                <td align="left" bgcolor="#D8F2C9" class="style45">
								<input name="webadd" type="text" value = "<%=rbean.getWebadd() %>"/></td>
                              </tr>
                              <tr>
                                <td align="left" bgcolor="#D8F2C9" class="style44">&nbsp;</td>
                                <td align="left" bgcolor="#D8F2C9" class="style44">&nbsp;</td>
                              </tr>
                              <tr>
                                <td align="left" bgcolor="#D8F2C9" class="style44">&nbsp;</td>
                                <td align="left" bgcolor="#D8F2C9" class="style44">&nbsp;</td>
                              </tr>
                            </table></td>
                        </tr>
                        
                      </table></td>
                    </tr>
                    <tr>
                      <th colspan="6" bgcolor="#FFFFD5" class="style38"><div align="left" class="bluetext">SPOUSE  DETAILS: </div></th>
                    </tr>
                    <tr>
                    
                      <td colspan="4" bgcolor="#0D62A2" class="style44"><table width="100%" border="0" cellpadding="0" cellspacing="0" class="greenlink_no_left_padding" style="border-right: #F8C9CA 1px solid; border-top: #F8C9CA 1px solid; border-left: #F8C9CA 1px solid;  border-bottom: #F8C9CA 1px solid; font-size: 9pt; color: #000000; font-family: Arial;">

                        <tr>
                          <td width="19%" class="greentext"><span class="style45">NAME OF THE SPOUSE:</span></td>
                          <td width="33%" class="style45">
						  <input name="spouse_name" type="text" id="spouse_name" value = "<%=rbean.getSpouse_name() %>"/></td>
                          <td width="26%" class="greentext"><span class="style45">SEX:</span></td>
                          <td width="22%" class="style45"><span class="style45">
                            <select name="ssex">
                              <option selected="selected"><%=rbean.getSsex() %> </option>
                              <option>Male</option>
                              <option>Female</option>
                            </select>
                          </span></td>
                        </tr>
                        <tr>
                          <td class="greentext"><span class="style45">DATE OF BIRTH:</span></td>
                          <td class="style45"><span class="style45">
                          <input type="text" name="sdob" id="sdob" size ="15" value = "<%=rbean.getSdob() %>"/>
                          <input name="b2" type="button" id="b2" value="..." />
                          <script type="text/javascript">
                                Zapatec.Calendar.setup({
                                    step              : 1,
                                    electric          : false,
                                    inputField        : "sdob",
                                    button            : "b2",
                                    ifFormat          : "%d-%m-%Y",
                                    daFormat          : "%d-%m-%Y"
                                });
                              </script>
                          </span></td>
                          <td class="greentext"><p class="style45">MARRIAGEANNIVERSARY:</p></td>
                          <td class="style45"><input type="text" name="marday" id ="marday" size="15"  value = "<%=rbean.getMar_aniv() %>"/>
                              <input name="bm" type="button" id="bm" value="..." />
                          <script type="text/javascript">
                                Zapatec.Calendar.setup({
                                    step              : 1,
                                    electric          : false,
                                    inputField        : "marday",
                                    button            : "bm",
                                    ifFormat          : "%d-%m-%Y",
                                    daFormat          : "%d-%m-%Y"
                                });
                            </script>                          </td>
                        </tr>
                        <tr>
                          <td class="greentext"><span class="style45">QUALIFICATION :</span></td>
                          <td class="style45"><span class="style45">
                            <select name="squal" id="squal">
                              <option selected="selected"><%=rbean.getSqual() %> </option>
                              <%
        ResultSet rs4 = stmt1.executeQuery();
        while (rs4.next() == true) {%>
                              <option> <%=rs4.getString(1)%></option>
                              <%
                                System.out.print("Spouse qualification table qualname " + rs4.getString(1));
        }%>
                            </select>
                          </span></td>
                          <td class="greentext"><span class="style45">PROFESSION</span></td>
                          <td class="style45"><span class="style45">
                            <select name="sprof" id="sprof">
                              <option selected="selected"><%=rbean.getProf() %> </option>
                              <%
        ResultSet rs5 = stmt2.executeQuery();
        while (rs5.next() == true) {
                                %>
                              <option><%=rs5.getString(1)%></option>
                              <%}%>
                            </select>
                          </span> </td>
                        </tr>
                        <tr>
                          <td class="greentext"><span class="style45">ORG/ COMPANY:</span></td>
                          <td class="style45"><input name="sorg" type="text" id="sorg" size="25" value = "<%=rbean.getSorg() %>"/></td>
                          <td class="greentext">&nbsp;</td>
                          <td class="style45">&nbsp;</td>
                        </tr>
                      </table></td>
                    </tr>
                    <tr>
                      <th colspan="6" bgcolor="#FFFFD5" class="style38"><div align="left" class="bluetext">CHILDREN  DETAILS: </div></th>
                    </tr>
                    <tr class="greenlink_no_left_padding">
                  
                      <td colspan="5" bgcolor="#0D62A2" class="style44">
                          <table width="100%" border="0" cellpadding="0" cellspacing="0" class="greenlink_no_left_padding" style="border-right: #F8C9CA 1px solid; border-top: #F8C9CA 1px solid; border-left: #F8C9CA 1px solid;  border-bottom: #F8C9CA 1px solid; font-size: 9pt; color: #000000; font-family: Arial;">
                        <tr>
                          <td bgcolor="#D8F2C9" class="greentext"><span class="style44">NAME OF THE CHILD</span></td>
                          <td bgcolor="#D8F2C9" class="greentext"><span class="style44">DATE OF BIRTH</span></td>
                          <td bgcolor="#D8F2C9" class="greentext"><span class="style44">SEX </span></td>
                          <td bgcolor="#D8F2C9" class="greentext"><span class="style44">QUALIFICATION </span></td>
                        </tr>
                        <tr>
                          <td bgcolor="#D8F2C9" class="style45">1)
                          <input name="c1name" type="text" id="c1name" value = "<%=rbean.getC1name() %>"/></td>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">
                            <input type="text" name="c1dob" id="c1dob"  size ="15" value = "<%=rbean.getC1dob() %>"/>
                            <input name="b3" type="button" id="b3" value="..." />
                            <script type="text/javascript">
                                    Zapatec.Calendar.setup({
                                        step              : 1,
                                        electric          : false,
                                        inputField        : "c1dob",
                                        button            : "b3",
                                        ifFormat          : "%d-%m-%Y",
                                        daFormat          : "%d-%m-%Y"
                                    });
                                </script>
                          </span></td>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">
                            <select name="c1sex" id ="c1sex">
                              <option selected="selected"><%=rbean.getC1sex() %> </option>
                              <option>Male</option>
                              <option>Female</option>
                            </select>
                          </span></td>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">
                            <select name="c1qual" id="c1qual">
                             <option selected="selected"><%=rbean.getC1qual()%> </option>
                              <% ResultSet rs6 = stmt1.executeQuery();
        while (rs6.next() == true) {%>
                              <option> <%=rs6.getString(1)%></option>
                              <%}%>
                            </select>
                          </span></td>
                        </tr>
                        <tr>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">2)
                              <input type="text" name="c2name" id="c2name" value = "<%=rbean.getC2name() %>"/>
                          </span></td>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">
                            <input type="text" name="c2dob" id="c2dob"  size ="15" value = "<%=rbean.getC2dob() %>"/>
                            <input name="b4" type="button" id="b4" value="..." />
                            <script type="text/javascript">
                                    Zapatec.Calendar.setup({
                                        step              : 1,
                                        electric          : false,
                                        inputField        : "c2dob",
                                        button            : "b4",
                                        ifFormat          : "%d-%m-%Y",
                                        daFormat          : "%d-%m-%Y"
                                    });
                                </script>
                          </span></td>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">
                            <select name="c2sex" id ="c2sex">
                              <option selected="selected"><%=rbean.getC2sex() %> </option>
                              <option>Male</option>
                              <option>Female</option>
                            </select>
                          </span></td>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">
                            <select name="c2qual" id="c2qual">
                             <option selected="selected"><%=rbean.getC2qual()%> </option>
                              <%
       								ResultSet rs7 = stmt1.executeQuery();
        							while (rs7.next() == true) {%>
                              <option> <%=rs7.getString(1)%></option>
                              <%}%>
                            </select>
                          </span></td>
                        </tr>
                        <tr>
                          <td bgcolor="#D8F2C9" class="style45">3)
                          <input type="text" name="c3name" id="c3name" value = "<%=rbean.getC3name() %>"/>                          </td>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">
                            <input type="text" name="c3dob" id="c3dob"  size ="15" value = "<%=rbean.getC3dob() %>" />
                            <input name="b5" type="button" id="b5" value="..." />
                            <script type="text/javascript">
                                    Zapatec.Calendar.setup({
                                        step              : 1,
                                        electric          : false,
                                        inputField        : "c3dob",
                                        button            : "b5",
                                        ifFormat          : "%d-%m-%Y",
                                        daFormat          : "%d-%m-%Y"
                                    });
                                </script>
                          </span></td>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">
                            <select name="c3sex" id ="c3sex">
                             <option selected="selected"><%=rbean.getC3sex()%> </option>
                              <option>Male</option>
                              <option>Female</option>
                            </select>
                          </span></td>
                          <td bgcolor="#D8F2C9" class="style45"><span class="style44">
                            <select name="c3qual" id="c3qual" >
                             <option selected="selected"><%=rbean.getC3qual()%> </option>
                              <%
        ResultSet rs8 = stmt1.executeQuery();
        while (rs8.next() == true) {%>
                              <option> <%=rs8.getString(1)%></option>
                              <%}%>
                            </select>
                          </span></td>
                        </tr>
                      </table></td>
    </tr>
                    <tr>
                      
                      <td width="130" height="22" bgcolor="#D8F2C9" class="style45"><div align="left" class="style44">Reffered By (member ID) </div></td>
                        <td height="22" colspan="3" bgcolor="#D8F2C9" class="style45"><div align="left" class="style44">
                          <input type="text" name="reffmemid" id="reffmemid" value = "<%=rbean.getReffmemberid() %>"/>
                      </div></td>
                    </tr>
                    <tr>
                   <td height="50" colspan="6" bgcolor="#FFFFD5" class="style44"><div align="left">
    <input type="checkbox" name="checkbox" id="checkbox" value="checkbox" checked="checked" />
						<span class="style39">I  <input type = "text" name = "decl" id = "decl"  disabled="disabled"/>
						a member of the Scheduled Caste Community, aged 
						<input type = "text" name = "declage" id = "declage"  disabled="disabled" size="10"/>
					  years, do here by take an oath and solemnly swear to be a member of &quot;SHANTI CHAKRA FOUNDATION&quot; and work towards the achievements of the organisation for the betterment and upliftment of my Community. </span> <span class="style39">I will be ever ready to support my people where ever whenever possible and support the theory of &quot;Helping each other and grow together&quot;. </span></div></td>
                    </tr>
                    <tr>
                    <td height="21" colspan="6" bgcolor="#D8F2C9" class="style44">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        &nbsp;&nbsp;&nbsp;</tr>
                    <tr bgcolor="#0D62A2">
                     
                        <td height="21" bgcolor="#D8F2C9" class="style46">&nbsp;</td>
                        <td width="297" align="center" bgcolor="#D8F2C9" class="style44">
						<div align="center" id="sbutton">
						  <input name="Submit" type="submit" class="bluetext" id="Submit" onClick="return validate(this.form)" value="SUBMIT" />
					  </div></td>
                      <td width="244" align="center" bgcolor="#D8F2C9" class="style44"><div align="center">
                        <input name="reset" type="reset" class="bluetext" id="reset" value="RESET" />
                      </div></td>
                        <td width="148" bgcolor="#D8F2C9" class="style44">&nbsp;</td>
                    </tr>
  </table>
</form>
</body>
</html>